var path = require("path");
daoModule = require("./DAO");
databaseModule = require(path.join(process.cwd(), "modules/database"));


module.exports.clearGoodAttributes = function (goods_id, cb) {
  db = databaseModule.getDatabase();
  sql = "DELETE FROM sp_goods_attr WHERE goods_id = ?";
  database.driver.execQuery(
    sql
    , [goods_id], function (err) {
      if (err) return cb("删除出错");
      cb(null);
    });
}

module.exports.list = function (goods_id, cb) {
  db = databaseModule.getDatabase();
  sql = "SELECT good_attr.goods_id,good_attr.attr_id,good_attr.attr_value,good_attr.add_price,attr.attr_name,attr.attr_sel,attr.attr_write,attr.attr_vals FROM sp_goods_attr as good_attr LEFT JOIN sp_attribute as attr ON attr.attr_id = good_attr.attr_id WHERE good_attr.goods_id = ?";
  database.driver.execQuery(
    sql
    , [goods_id], function (err, attrs) {
      if (err) return cb("删除出错");
      cb(null, attrs);
    });
}